package com.scpii.universal;

import org.mybatis.generator.lenovo.GeneratorForSql;
/**
 * xml,mapper java,domain java
 * @author yangyong3
 *
 */
public class SelectByMap {
	
	public static void main(String[] args) throws Exception {
		
		String driverClass = "oracle.jdbc.driver.OracleDriver";
	    String connectionUrl = "jdbc:oracle:thin:@218.6.170.246:1521:UNIVERSALDB";
	    
	    String sourceSrc = "E:\\SVN\\trunk\\dispatch\\universaldispatch\\src";
	    String sourceConfig = "E:\\SVN\\trunk\\dispatch\\universaldispatch\\src";

	    String mapper = "com.scpii.universal.entity.mapper.QryTaskMapper";
	    String domain = "com.scpii.universal.entity.model.QryTask";
	    
	    String sql_str = "select task.INT_COMPILE_TASK_ID," +
	    				 "task.VAR_CONFIG_NAME," +
	    				 "apu.* " +
	    				 "from COMPILE_TASK_TAB task,APP_UPDATE_TAB apu " +
	    				 "where task.INT_APP_UPDATE_ID = apu.INT_APP_UPDATE_ID(+) " +
	    				 "and task.INT_STATUS = 0";

	    int pkNum = 0;
	  
	    GeneratorForSql.startQryData(pkNum,sourceSrc,sourceConfig,mapper,domain, sql_str,driverClass,connectionUrl,"ADMIN","Buildapp123");
	}
}
